﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Slam.Administration.Data
{
	internal static class Queries
	{
		public static string RetrieveRecentMessageLogMessages
		{
			get 
			{
				return @"select top 50 MessageDate, MessageType, Message 
						from SLAM.MessageLog 
						where MessageDate > dateadd(day, -30, GETDATE()) and Message not like 'Trace Level:%' order by MessageLogID desc";
			}
		}

		public static string VerifyMessageLogExists
		{
			get
			{
				return "select count(*) FROM information_schema.tables where table_schema = 'SLAM' and table_name = 'MessageLog'";
			}
		}
	}
}
